package com.hist.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.hist.entity.AllScore;
import com.hist.entity.Student;

@Mapper
public interface StudentDao {

	      @Select("select * from studentmanagement.student where sno=#{sno}")
	      List<Student> checkMyCV(Integer sno);
	      @Select("select studentmanagement.score.sno as sno,sname as sname,smajor as smajor,sgrade as sgrade,studentmanagement.course.cno as cno,cname as cname,score as score from studentmanagement.student,studentmanagement.course,studentmanagement.score where studentmanagement.student.sno=studentmanagement.score.sno and studentmanagement.course.cno=studentmanagement.score.cno and studentmanagement.score.sno=#{sno}")
	      List<AllScore> checkMyScore(Integer cno);
	    
}
